Entity Relationships - Objectives (MODULE)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
MODULE	Modules	MODCODE				Stores details of objectives at all levels (e.g. modules, units, elements, etc).
TRMODULE	Trainee-Module Link	TRAINEEID, TRMODULEID	MODULE	One to many	MODCODE	Links trainees to objectives and stores trainee-specific information about objective, such as start date, completion date, etc.
MODULEEVIDENCE	Module Evidence	EVIDENCEID	MODULE	One to many	MODCODE	Stores the evidence criteria details for each objective.
EVENTEVIDENCE	Event Evidence	Q_EVENTID, EVIDENCEID	MODULEEVIDENCE	One to many	EVIDENCEID	Stores information on the evidence criteria addressed during an event (e.g. an assessment).
TRMODULEEVENT	Trainee Module Event	Q_EVENTID, TRAINEEID	TRMODULE, EVENTEVIDENCE	One to one	(From TRMODULE) TRAINEEID, MODCODE, TRMODULEID; (from EVENTEVIDENCE) Q_EVENTID, TRMODULEID	Lists events associated with a trainee's objectives. It links to both TRMODULE (for trainee and module details) and EVENTEVIDENCE (for event details).
TRMODULEFILES	Trainee Module Files	TRAINEEID, TRMODULEID, FILEID	TRMODULE	One to one	TRAINEEID, TRMODULEID, MODCODE	Lists files associated with each of a trainee's objectives.
TRAINEEPORTFOLIO	Trainee Portfolio	TRAINEEID, FILEID	TRMODULEFILES	One to one	TRAINEEID, FILEID	Stores details of files associated with a trainee.
ROUTES	Routes	ROUTEID	TRMODULE	One to one	ROUTEID	Stores information on a trainee's objectives route.
ASSESSORMODULE	Assessor-Module Link	ASSESSORID, ASSMODULEID	MODULE	One to many	MODCODE	Links assessors to objectives.
COURSEMODULE	Course-Module Link	CMODULEID, COURSEID	MODULE	One to many	MODCODE	Links courses to objectives.